Working With Formats and Line Types

Financial reports created by the FRW consist of a series of rows and columns with a heading (title). Column formats define the vertical positions of financial data in a report, and row formats define the report lines that are contained within a financial report.

Line types are the essence of the FRW, since they provide the majority of the control you need to customize your agency's financial reports.

Column Formats

Row Formats

Create a New Row Format
Edit a Row Format

Line Types

Column Formats

Column formats define the vertical positions of financial data in a report. Column formats are provided by WinTen² and cannot be altered, but you can choose from a number of different formats:

Note: Dollar/numeric values are the balances as of the selected report date.

Column Format	Description
Balance - Current Period and YTD	Balance Sheet - Current Period and YTD.
Balance - YTD	Balance Sheet - standard format, YTD balances as of report date.
Balance - YTD with Prior Year Comparison	Balance Sheet - YTD with prior year comparison.
Budget Comparison - Current Period	Income Statement - Current Period Budget Comparison with Percent Budget Used; includes YTD amounts but budget comparison is only for current period.
Budget Comparison - Current Period and YTD	Income Statement - Budget Comparison of Current Period and YTD.
Encumbrance Report	Includes Encumbrance column; encumbrances come from Purchase Order program only.
Income Statement - Budget Comparison	Income Statement - Budget Comparison Current Period and YTD.
Income Statement - Four Column	Income Statement - Current Period and YTD Ending Balance.
Income Statement - Prior Year Comparison	Income Statement - Prior Year Comparison of Current Period and YTD.
PUM - Current Period	Income Statement PUM - Current Period only; PUM: Per Unit Month, requres a unit count for projects.

Row Formats

Financial report customization relies primarily on row format because row formats define the horizontal report lines that are contained within a financial report.

The row format of a report is defined under a particular line type(s), and the line type(s) determines what is displayed or calculated on the report.

You can only use existing, defined row formats at the time you are creating a new report. If you want to create a new row format, you must first create the report and then access the Row Format tool to create a new row format for it.

You will need to add a row for each line, or group of lines, in a report. This gives you complete control over all the lines within a financial report!

Create a New Row Format

Select Report

You must first select the report in which you want to use the new row format.

On the Maintain Financial Report screen, highlight the report you want to work with from the table.

Click

and select “Edit Row Format” from the menu that appears. The Maintain Detail Line screen appears.

Click

on the toolbar. The Add Report Detail Line screen opens.

Specify Line Type

Each row of a report is defined under a particular line type(s), and the line type(s) determines what is displayed or calculated on the report.

Select the report line type from the drop-down menu. The specified line type's details will display on the screen. (The displayed information will differ for each line type.)

Select the checkbox to reverse signs on printing, if desired. This reverses credits to positive amounts and debits to negative amounts.

Select the checkbox to print.

Select the checkbox if the row amount is currency (only applies to FDS Report formats).

Click OK to save your changes and return to the Maintain Detail Line screen.

Click ADD ANOTHER to save your changes and clear the screen to add a new line type to the row format.

Edit a Row Format

When editing a row format, you are actually editing the line types that define it.

Select Report

You must first select a report which includes the row format you want to work with.

On the Maintain Financial Report screen, highlight the report you want to work with in the report table.

Access Row Format Tool

Click

and select “Edit Row Format” from the menu that appears. The Maintain Detail Line screen appears.

Select Line Type

Highlight the line type of the row format that you want to edit from the line type table.

Click on the toolbar. The Add Report Detail Line screen opens.

Edit Line Type Details

Edit the report line type, if necessary. The specified line type's details will display.

Edit the line description and details, as necessary.

Click OK to save your changes and return to the Maintain Detail Line screen.

Click CANCEL to exit the screen without saving your changes.

Click ADD ANOTHER to save your changes and clear the screen to add a new line type to the row format.

Note: To delete a line type, highlight the line type you want to delete from the line type table, click on the toolbar, and then click YES through the confirmation message.

More on the Maintain Detail Line Screen

Line Types

Each row of a report is defined under a particular line type, and the line type determines what is displayed or calculated on the report. Specifically, line types:

Format the report

Display groups of account lines

Handle calculations

Line Type	Description
Blank Line	Prints a single blank line on the report. (Recommended to start report with at least 1 blank line.)
Detail Account Type	Prints all accounts that are of a specified account type.
Double Underscore	Prints a double underscore line.
Draw Horizontal Line	Prints a horizontal line across the page to separate groups.
FDS Account Code	Prints all accounts that correspond to the selected FDS code.
GL Account Line	Prints a single GL account. The account is specific and the fund selection for the report will not override the selected account. Note: Only use this type if you are reporting on one fund.
GL Account Mask	Prints all GL accounts that match the account mask. Example: ???.1111.??.??? will pull all accounts that have 1111 as the line item.
GL Account Range	Prints all accounts within a specified range. The selected fund for the report will not override the account selection. Note: Only use this type if you are reporting on one fund.
HUD Account Code	Prints all accounts that correspond to a specific HUD account code.
Page Break	Starts the next line on a new page.
Report Group #1	Prints all accounts that correspond to a specific user-defined report field #1. Note: Reporting code for account given on the Main Tab on Maintain Active Accounts under Maintain Chart of Accounts.
Report Group #2	Prints all accounts that correspond to a specific user-defined report field #1.
Report Group #3	Prints all accounts that correspond to a specific user-defined report field #1.
Title Centered on Page	Prints a title line that is centered on the page.
Title in Description Column	Prints a title line in the Description column.
Title Left of Page	Prints a title line on the left of the page.
Title Right of Page	Prints a title line on the right of the page.
Total Line	Prints a total line from a report variable.
Underscore Amounts	Prints a single underscore line under amounts.